INSERT INTO t_delivery_type (delivery_type_code, delivery_type_name, delivery_type_description)
VALUES ('COLLST', 'Collection from store', 'The consumer chooses to collect the goods from store')
;
INSERT INTO t_delivery_type (delivery_type_code, delivery_type_name, delivery_type_description)
VALUES ('DELTAD', 'Delivery to Address', 'The consumer chooses to have goods delivered to the address specified')
;
INSERT INTO t_delivery_type (delivery_type_code, delivery_type_name, delivery_type_description)
VALUES ('DIGDEL', 'Digital Delivery', 'The consumer chooses to receive the digital delivery of item purchased')
;

INSERT INTO t_message_group_type (message_group_type, message_group_name, message_group_description)
VALUES ('TRANSITIONEVNT', 'Payment Order transition event', 'This is used for all the messages which have come for the order payment lifecycle')
;
INSERT INTO t_message_group_type (message_group_type, message_group_name, message_group_description)
VALUES ('ADHOCEVNT', 'Adhoc queries event', 'This is used to identify adhoc requests such as transaction history etc.')
;
INSERT INTO t_message_group_type (message_group_type, message_group_name, message_group_description)
VALUES ('MERCHANTEVNT', 'Merchant activity event', 'This is used to identify the events related to merchant (onboarding etc)')
;
INSERT INTO t_message_group_type (message_group_type, message_group_name, message_group_description)
VALUES ('CONSUMEREVNT', 'Consumer activity event', 'This is used to identify the events related to consumers (registration etc)')
;

INSERT INTO t_response_code (response_code, response_code_name, response_code_description)
VALUES ('GEOLOERROR', 'Georeference error', 'Geo location did not match with the record')
;
INSERT INTO t_response_code (response_code, response_code_name, response_code_description)
VALUES ('DEVICERROR', 'Device not matching', 'The Device finger print could not match with the record')
;
INSERT INTO t_response_code (response_code, response_code_name, response_code_description)
VALUES ('CREDEERROR', 'Inbrowser Credentials error', 'Credentials invalid')
;
INSERT INTO t_response_code (response_code, response_code_name, response_code_description)
VALUES ('MSGCTERROR', 'Message Content error', 'Error in the content of the message')
;
INSERT INTO t_response_code (response_code, response_code_name, response_code_description)
VALUES  ('SUCCESSFUL', 'No error detected', 'The request has passed through all the validations')
;

INSERT INTO t_transaction_checkout_type (transaction_checkout_type,checkout_type_name, checkout_type_description)
VALUES ('QKPACHK', 'QuickPay', 'This is the Zapp quickpay checkout')
;
INSERT INTO t_transaction_checkout_type(transaction_checkout_type,checkout_type_name, checkout_type_description)
VALUES ('NRMLCHK', 'Normal Check out', 'This indicates the normal checkout process of the merchant site')
;

INSERT INTO t_transaction_channel (transaction_channel_code, channel_name, channel_description)
VALUES ('MOBAP', 'Bank''s Mobile App Zapp', 'If the payment is done through bank''s Zapp App')
;
INSERT INTO t_transaction_channel (transaction_channel_code, channel_name, channel_description)
VALUES ('CONSPOR', 'Zapp Consumer Portal', 'If the system is accessed through Zapp Consumer Portal')
;

INSERT INTO t_transaction_type (transaction_type, transaction_type_name, transaction_type_description)
VALUES ('BILLPT', 'BillPayment', 'Bill payment')
;
INSERT INTO t_transaction_type (transaction_type, transaction_type_name, transaction_type_description)
VALUES ('PAYMT', 'Payment', 'Payment of purchased product')
;
INSERT INTO t_transaction_type (transaction_type, transaction_type_name, transaction_type_description)
VALUES ('PREAT', 'Pre-Authorization', 'Reservation(Pre-Authorization)')
;
INSERT INTO t_transaction_type (transaction_type, transaction_type_name, transaction_type_description)
VALUES ('REFUND', 'Refund', 'Refund payment')
;


INSERT INTO t_message_type (message_type_code, message_type_name, message_group_type, message_description)
VALUES ('ACKADDMERCHANT', 'Acknowledgement to Add Merchant request', 'MERCHANTEVNT', 'This indicates acknowledgement to Add Merchant request')
;
INSERT INTO t_message_type (message_type_code, message_type_name, message_group_type, message_description)
VALUES('ACKCONSREGISTRATION', 'Acknowledgement to Consumer Registration Request', 'CONSUMEREVNT', ' This indicates acknowledgement to Consumer Registration Request')
;
INSERT INTO t_message_type (message_type_code, message_type_name, message_group_type, message_description)
VALUES ('ADDMERCHANT', 'Request to add a merchant', 'MERCHANTEVNT', 'This indicates Request to add a merchant')
;
INSERT INTO t_message_type (message_type_code, message_type_name, message_group_type, message_description)
VALUES ('CONFIRMPAYMENT', 'Payment Confirmation', 'TRANSITIONEVNT', 'This indicates that the payment confirmation')
;
INSERT INTO t_message_type (message_type_code, message_type_name, message_group_type, message_description)
VALUES ('INBROWSERPAYMTINS', 'Inbrowser payment Instruction', 'TRANSITIONEVNT', 'The payment instruction request in ''Zapp'' Inbrowser payments')
;
INSERT INTO t_message_type (message_type_code, message_type_name, message_group_type, message_description)
VALUES ('NOTIFICATION', 'Notification general', 'TRANSITIONEVNT', 'This indicates general notification')
;
INSERT INTO t_message_type (message_type_code, message_type_name, message_group_type, message_description)
VALUES ('NOTIFYPAYMENT', 'Payment Notification', 'TRANSITIONEVNT', 'This indicates the payment notification')
;
INSERT INTO t_message_type (message_type_code, message_type_name, message_group_type, message_description)
VALUES ('REGISTERCONSUMER', 'Consumer Regsitration for AP service', 'CONSUMEREVNT', 'Notification of Bank''s customer registration for AP service')
;
INSERT INTO t_message_type (message_type_code, message_type_name, message_group_type, message_description)
VALUES ('REQREFUNDACCNO', 'Request Refund Account Number', 'TRANSITIONEVNT', 'Distributor Requesting Account Details of the Consumer to perform a refund')
;
INSERT INTO t_message_type (message_type_code, message_type_name, message_group_type, message_description)
VALUES ('REQUEST RTP STATUS', 'Request for status', 'ADHOCEVNT', 'Request for the status of a transaction')
;
INSERT INTO t_message_type (message_type_code, message_type_name, message_group_type, message_description)
VALUES ('RESPONSETORTP', 'Response to RTP', 'TRANSITIONEVNT', 'The response to the ''Submit RTP/Submit RTP with OTT/Submit RTP for Inbrowser Payment/Submit RTP for bill payment''')
;
INSERT INTO t_message_type (message_type_code, message_type_name, message_group_type, message_description)
VALUES ('RESPONSETORTPSTATUS', 'Response for the status request', 'TRANSITIONEVNT', 'Response to the status request of the  transaction')
;
INSERT INTO t_message_type (message_type_code, message_type_name, message_group_type, message_description)
VALUES ('RESPREFUNDACCNO', 'Response to Request Refund Account Number', 'TRANSITIONEVNT', 'The refund account number is passed back to the distributor')
;
INSERT INTO t_message_type (message_type_code, message_type_name, message_group_type, message_description)
VALUES ('RESPTOTRANSHIST', 'Response to Transaction History', 'ADHOCEVNT', 'Response to the retrieve transaction history request from the consumer bank')
;
INSERT INTO t_message_type (message_type_code, message_type_name, message_group_type, message_description)
VALUES ('RETRIEVERTP', 'Retrieve RTP', 'TRANSITIONEVNT', 'The request to retrieve the RTP corresponding to the OTT')
;
INSERT INTO t_message_type (message_type_code, message_type_name, message_group_type, message_description)
VALUES ('RETRIEVETRANSHIST', 'Retrieve Transaction History', 'ADHOCEVNT', 'Request from the Consumer Bank to retreive the consumer transaction history')
;
INSERT INTO t_message_type (message_type_code, message_type_name, message_group_type, message_description)
VALUES ('RTPFORAUTH', 'RTP for Authorization', 'TRANSITIONEVNT', 'The ''request to pay'' notification in order to make the payment')
;
INSERT INTO t_message_type (message_type_code, message_type_name, message_group_type, message_description)
VALUES ('SUBMITRTPFORBILLPAY', 'Submit RTP for bill payment', 'TRANSITIONEVNT', 'The submission of request to pay for Utility Bills')
;
INSERT INTO t_message_type (message_type_code, message_type_name, message_group_type, message_description)
VALUES ('SUBMITRTPFORBRN', 'Submit RTP for Basket Reference Number', 'TRANSITIONEVNT', 'The submission of request to Pay through E-com for the generation of Basket Reference Number')
;
INSERT INTO t_message_type (message_type_code, message_type_name, message_group_type, message_description)
VALUES ('SUBMITRTPFORMOB', 'Submit RTP  from Mobile-mcom browser for requesting uniqie transaction id', 'TRANSITIONEVNT', 'The submission of request to Pay for the generation of transaction Id')
;
INSERT INTO t_message_type (message_type_code, message_type_name, message_group_type, message_description)
VALUES ('UNKNOWNTRANSITIONMSG', 'Unknown transition message type', 'TRANSITIONEVNT', 'Unknown transition message type')
;
INSERT INTO t_message_type (message_type_code, message_type_name, message_group_type, message_description)
VALUES ('UNKNOWNADHOCMSG', 'Unknown adhoc message type', 'ADHOCEVNT', 'Unknown adhoc message type')
;
INSERT INTO t_message_type (message_type_code, message_type_name, message_group_type, message_description)
VALUES ('UNKNOWNMERCHANTMSG', 'Unknown Merchant message type', 'MERCHANTEVNT', 'Unknown Merchant message type')
;
INSERT INTO t_message_type (message_type_code, message_type_name, message_group_type, message_description)
VALUES ('UNKNOWNCONSUMERMSG', 'Unknown Consumer message type', 'CONSUMEREVNT', 'Unknown Consumer message type')
;

INSERT INTO t_message_timeout (message_type_code, transaction_channel_code, timeout_seconds)
VALUES ('SUBMITRTPFORMOB', 'MOBAP', 90)
;
INSERT INTO t_message_timeout (message_type_code, transaction_channel_code, timeout_seconds)
VALUES ('SUBMITRTPFORBRN', 'MOBAP', 120)
;

INSERT INTO t_fps_status (fps_status_code, fps_status_name, status_description)
VALUES ('SUCCE', 'Successful', 'The Transaction is successful')
;
INSERT INTO t_fps_status (fps_status_code, fps_status_name, status_description)
VALUES ('FAILED', 'Failed', 'The Transaction has failed')
;
INSERT INTO t_fps_status (fps_status_code, fps_status_name, status_description)
VALUES ('INPROC', 'Inprocess', 'the Transaction is in process')
;

INSERT INTO t_payment_failure_type (payment_failure_code, payment_failure_name, failure_description)
VALUES('INSUFFICIENTFUND', 'Insufficient fund','Account does not have sufficient funds')
;
INSERT INTO t_payment_failure_type (payment_failure_code, payment_failure_name, failure_description)
VALUES('ACCTBLKD', 'Account Blocked', 'Account is not accessible')
;
INSERT INTO t_payment_failure_type (payment_failure_code, payment_failure_name, failure_description)
VALUES('OTHER', 'others', NULL)
;

INSERT INTO t_device_app_intent (device_appintent_id, device_os, os_version, app_intent)
VALUES (device_appintent_id_seq.NEXTVAL, 'AND', '1.0', 'dummyAndroidppintent')
;
INSERT INTO t_device_app_intent (device_appintent_id, device_os, os_version, app_intent)
VALUES (device_appintent_id_seq.NEXTVAL, 'IOS', '1.0', 'dummyAppleIOSappintent')
;
INSERT INTO t_device_app_intent (device_appintent_id, device_os, os_version, app_intent)
VALUES (device_appintent_id_seq.NEXTVAL, 'WIN', '1.0', 'dummyWindowsappintent')
;

INSERT INTO t_amount_type (amount_type_code, amount_type_name, amount_type_description)
VALUES ('DELC', 'Delivery cost', 'Any delivery charges levied')
;
INSERT INTO t_amount_type (amount_type_code, amount_type_name, amount_type_description)
VALUES ('FEES', 'Fees', 'Fees')
;
INSERT INTO t_amount_type (amount_type_code, amount_type_name, amount_type_description)
VALUES ('RBTS', 'Rebates', 'Global rebate of the transaction.This amount is counted as a negative amount')
;
INSERT INTO t_amount_type (amount_type_code, amount_type_name, amount_type_description)
VALUES ('VATX', 'ValueAddedTax', 'Value added tax')
;
INSERT INTO t_amount_type (amount_type_code, amount_type_name, amount_type_description)
VALUES ('CSHB', 'Cashback', 'cash-back amount')
;

INSERT INTO t_measure_unit (measure_unit_code, measure_unit_name, measure_unit_description)
VALUES ('CMET', 'Centimetre', 'One 100th part of a metre.')
;
INSERT INTO t_measure_unit (measure_unit_code, measure_unit_name, measure_unit_description)
VALUES ('FOOT', 'Foot', 'Unit of length equal to 1/3 yard.')
;
INSERT INTO t_measure_unit (measure_unit_code, measure_unit_name, measure_unit_description)
VALUES ('GBGA', 'GBGallon ', 'Unit of volume that is equal to 8 pints.')
;
INSERT INTO t_measure_unit (measure_unit_code, measure_unit_name, measure_unit_description)
VALUES ('GBOU', 'GBOunce', 'Unit of weight equal to a sixteenth of a pound.')
;
INSERT INTO t_measure_unit (measure_unit_code, measure_unit_name, measure_unit_description)
VALUES ('GBPI', 'GBPint ', 'Unit of volume that is equal to 568 cubic centimetres.')
;
INSERT INTO t_measure_unit (measure_unit_code, measure_unit_name, measure_unit_description)
VALUES ('GBQA', 'GBQuart', 'Unit of volume that is equal to 2 pints.')
;
INSERT INTO t_measure_unit (measure_unit_code, measure_unit_name, measure_unit_description)
VALUES ('GRAM', 'Gram', 'Unit of measure that is equal to a 1,000th of a kilo.')
;
INSERT INTO t_measure_unit (measure_unit_code, measure_unit_name, measure_unit_description)
VALUES ('HECT', 'Hectare', 'Unit of measure that is equal to 10,000 square meters.')
;
INSERT INTO t_measure_unit (measure_unit_code, measure_unit_name, measure_unit_description)
VALUES ('INCH', 'Inch', 'Measure of length equal to 2.54 cm.')
;
INSERT INTO t_measure_unit (measure_unit_code, measure_unit_name, measure_unit_description)
VALUES ('KILO', 'Kilogram', 'Basic unit of mass in the SI system, 1000 grams.')
;
INSERT INTO t_measure_unit (measure_unit_code, measure_unit_name, measure_unit_description)
VALUES ('KMET', 'Kilometre', 'Unit of measure that is equal to 1,000 meters.')
;
INSERT INTO t_measure_unit (measure_unit_code, measure_unit_name, measure_unit_description)
VALUES ('LITR', 'Litre', 'Unit of volume that is equal to a thousand cubic centimetres.')
;
INSERT INTO t_measure_unit (measure_unit_code, measure_unit_name, measure_unit_description)
VALUES ('METR', 'Meter', 'Unit of length')
;
INSERT INTO t_measure_unit (measure_unit_code, measure_unit_name, measure_unit_description)
VALUES ('MILE', 'Mile ', 'Unit of length equal to 1,760 yards')
;
INSERT INTO t_measure_unit (measure_unit_code, measure_unit_name, measure_unit_description)
VALUES ('MILI', 'MilliLitre', 'Unit of volume that is equal to one thousandth of a litre.')
;
INSERT INTO t_measure_unit (measure_unit_code, measure_unit_name, measure_unit_description)
VALUES ('MMET', 'Millimetre', 'Unit of measure that is a thousandth of one metre.')
;
INSERT INTO t_measure_unit (measure_unit_code, measure_unit_name, measure_unit_description)
VALUES ('PIEC', 'Piece', 'Standard length of cloth, wallpaper, as an item for sale or amount of a substance.')
;
INSERT INTO t_measure_unit (measure_unit_code, measure_unit_name, measure_unit_description)
VALUES ('PUND', 'Pound', 'Unit of weight equal to 0.454 kilograms.')
;
INSERT INTO t_measure_unit (measure_unit_code, measure_unit_name, measure_unit_description)
VALUES ('SCMT', 'SquareCentimetre', 'Measure of a surface, one centimetre by one centimetre.')
;
INSERT INTO t_measure_unit (measure_unit_code, measure_unit_name, measure_unit_description)
VALUES ('SMET', 'SquareMetre', 'Measure of a surface, one metre by one metre.')
;
INSERT INTO t_measure_unit (measure_unit_code, measure_unit_name, measure_unit_description)
VALUES ('SMIL', 'SquareMillimetre', 'Measure of a surface, one millimetre by one millimetre.')
;
INSERT INTO t_measure_unit (measure_unit_code, measure_unit_name, measure_unit_description)
VALUES ('SQFO', 'SquareFoot', 'Measure of a surface, one foot by one foot.')
;
INSERT INTO t_measure_unit (measure_unit_code, measure_unit_name, measure_unit_description)
VALUES ('SQIN', 'SquareInch', 'Measure of a surface, one inch by one inch.')
;
INSERT INTO t_measure_unit (measure_unit_code, measure_unit_name, measure_unit_description)
VALUES ('SQKI', 'SquareKilometre', 'Measure of a surface, one kilometre by one kilometre.')
;
INSERT INTO t_measure_unit (measure_unit_code, measure_unit_name, measure_unit_description)
VALUES ('SQMI', 'SquareMile', 'Measure of a surface, one mile by one mile.')
;
INSERT INTO t_measure_unit (measure_unit_code, measure_unit_name, measure_unit_description)
VALUES ('SQYA', 'SquareYard', 'Measure of a surface, one yard by one yard.')
;
INSERT INTO t_measure_unit (measure_unit_code, measure_unit_name, measure_unit_description)
VALUES ('TONS', 'Ton', 'Measure of weight, in Britain 2240lb (long ton)and in the US 2000lb (short ton).')
;
INSERT INTO t_measure_unit (measure_unit_code, measure_unit_name, measure_unit_description)
VALUES ('USGA', 'USGallon', 'Unit of volume that is equal to 8 pints.')
;
INSERT INTO t_measure_unit (measure_unit_code, measure_unit_name, measure_unit_description)
VALUES ('USOU', 'USOunce', 'Unit of weight equal to a sixteenth of a pound.')
;
INSERT INTO t_measure_unit (measure_unit_code, measure_unit_name, measure_unit_description)
VALUES ('USPI', 'USPint', 'Unit of volume that is equal to 473 cubic centimetres.')
;
INSERT INTO t_measure_unit (measure_unit_code, measure_unit_name, measure_unit_description)
VALUES ('USQA', 'USQuart', 'Unit of volume that is equal to 2 pints.')
;
INSERT INTO t_measure_unit (measure_unit_code, measure_unit_name, measure_unit_description)
VALUES ('YARD', 'Yard', 'Unit of length equal to 3 feet or 0.9144 metre.')
;


INSERT INTO t_refund_type (refund_type_code, refund_type_name, refund_type_description)
VALUES ('CHARGEBACK','Charge Back','Charge Back')
;
INSERT INTO t_refund_type (refund_type_code, refund_type_name, refund_type_description)
VALUES ('CONSUMERREFUND','Consumer Refund','Consumer Refund')
;

INSERT INTO t_parameter (parameter_id, parameter_name, parameter_value, parameter_description)
VALUES (1, 'VIEW_TRANS_HISTORY', '90', 'Parameter to define the number of days the AP transaction history will be available upto for view by the consumer')
;
INSERT INTO t_parameter (parameter_id, parameter_name, parameter_value, parameter_description)
VALUES (2, 'LOGGING_ENABLED', 'Y', 'Logging flag for Progress_Log')
;
INSERT INTO t_parameter (parameter_id, parameter_name, parameter_value, parameter_description)
VALUES (3, 'AP_CONSUMER_PORTAL', 'http://www.zapp.com/cosumerportal', 'Zapp Consumer Portal')
;

INSERT INTO t_reconciliation_parameter (serial_number, start_time, end_time)
VALUES ('01', TO_TIMESTAMP('01/01/1900 00:00:00.000000', 'DD/MM/YYYY HH24:MI:SS.FF'), TO_TIMESTAMP( '01/01/1900 23:59:59.999999', 'DD/MM/YYYY HH24:MI:SS.FF'))
;

INSERT INTO t_activation_status ( activation_status_code, activation_status_name, status_description)
VALUES ('REGISTERED', 'Registered', 'The participant  has been registered, In case of Consumer email verification is required')
;
INSERT INTO t_activation_status ( activation_status_code, activation_status_name, status_description)
VALUES ('PNDGACTIVE', 'Pending Active', 'The participant activation is pending')
;
INSERT INTO t_activation_status ( activation_status_code, activation_status_name, status_description)
VALUES ('ACTIVE', 'Active', 'The participant is active on the service')
;
INSERT INTO t_activation_status ( activation_status_code, activation_status_name, status_description)
VALUES ('SUSPENDED', 'Suspended', 'The participant has been suspended')
;
INSERT INTO t_activation_status ( activation_status_code, activation_status_name, status_description)
VALUES ('DEREGISTERED', 'de-registered', 'The participant has been de-registered from the service')
;

INSERT INTO t_distributor_category ( distributor_category_code, distributor_category_name, category_description)
VALUES ('L1', 'Level1', 'Level 1')
;
INSERT INTO t_distributor_category ( distributor_category_code, distributor_category_name, category_description)
VALUES ('L2', 'Level2', 'Level 2')
;
INSERT INTO t_distributor_category ( distributor_category_code, distributor_category_name, category_description)
VALUES ('L3', 'Level3', 'Level 3')
;

COMMIT
;
